home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
EnigmA Amiga Run 1996 February
/
EnigmA AMIGA RUN 04 (1996)(G.R. Edizioni)(IT)[!][issue 1996-02][Skylink CD III].iso
/
earcd
/
patches
/
fc_n1113.lha
/
Changes_1.03
< prev
next >
Wrap
Text File
|
1995-12-04
|
11KB
|
314 lines
FinalCalc 1.03 changes:
-----------------------
4 December 1995
This file describes changes and additions to FinalCalc from release 1.0
to release 1.03:
///////////////////////////////////////////////////////////////////////////////
New Import Module: ProCalc, Advantage and Gold Disk Office files:
------------------------------------------------------------------
FinalCalc now detects and imports the FAFF file format, which is used by
ProCalc, Advantage (1.1 and above), and Gold Disk Office.
The module handles cell and formula contents and styles. Style tags,
fonts and colors are loaded, too. Style tags are converted into FinalCalc
format tags.
Database input and criteria ranges are imported correctly. All database
criteria cells are converted into a format usuable by FinalCalc. ("FIELD"
is added to them, so a criteria of ">11" becomes "FIELD>11"). Database
formula functions are also converted.
Many functions are converted into suitable FinalCalc functions when loading:
Function: Converted to:
------------------------------ ---------------------------------------
HOUR() HOUR(NOW)
MINUTES() (MINUTE(NOW)+(HOUR(NOW)*60))
SECONDS() (MINUTE(NOW)+(HOUR(NOW)*60))*60+SECOND(NOW))
POWER(value,power) value^power
WEEKDAY(value) (value % 7)
LINKDISK(filename,cell) {filename}cell
E() EXP(1)
DATE(month,day,year) DATE(year,month,day)
PRINTIF() IF()
SAYIF() IF()
COLOR(test,true,false) SETCOLOR(HERE,IF(test,true,false))
STYLE(test,true,false) SETSTYLE(HERE,IF(test,true,false))
SETCOLOR(test,true,false,cell) SETCOLOR(cell,IF(test,true,false))
SETSTYLE(test,true,false,cell) SETSTYLE(cell,IF(test,true,false))
CELL(row offset,column offset) HERE(column offset,row offset)
RANGE(row1,col1,row2,col2) RANGE(col1,row1,col2,row2)
(note that columns in FAFF files start at 1,
not 0 like FinalCalc)
Unsupported Functions: (cannot be converted into FinalCalc functions)
---------------------------------------------------------------------
AND(list)
FVV(rate,range)
ISNV(cell)
LCELL(name,cell)
LRANGE(filename,range)
LOGA(base,value)
OR(list)
REXX(ARexx filename,list)
TYPE(cell)
@(cell)
///////////////////////////////////////////////////////////////////////////////
System Clipboard support:
------------------------
FinalCalc now supports the system clipboard to copy and paste text from other
applications. There are two ways to get text from the clipboard and two ways
to send text to the clipboard:
- Copy to Clipboard:
The Edit-Copy menu now has sub-menus. The 'Edit-Copy-Copy' works as before,
but a new item 'Edit-Copy-Copy to Clipboard' copies the current cell or
range as text to the sytem clipboard.
- Paste from Clipboard:
The 'Edit-Paste-Paste from Clipboard' menu item pastes the system clipboard
contents starting at the current cell, and downwards as a single column.
This is stored as as undo event, so you can undo and redo it.
- Export Text to Clipboard:
The 'Project-Text-Export to Clipboard' exports the current cell or range as
text using the current Text Export Settings to the system clipboard.
- Import Text from Clipboard:
The 'Project-Text-Import from Clipboard' imports the system clipboard
contents using the current Text Import Settings starting at the current
cell. This is stored as as undo event, so you can undo and redo it.
The following script commands have been added to support the above functions:
COPY CLIPBOARD
PASTE CLIPBOARD
EXPORT CLIPBOARD
IMPORT CLIPBOARD
///////////////////////////////////////////////////////////////////////////////
Printing:
---------
- FinalCalc is now more intelligent in deciding how many bands to print a
page in when in Preferences printing mode. This normally results in
printing that takes about half the time it used to.
- If printing to Preferences or Laserjet printers fails for any reason,
FinalCalc now brings up a requester informing the user of what the reason
was. It will also mark the job as "Failed" in the Spool requester.
- When printing multiple jobs in one go, the spooler is not launched until
the last job has been sent. This speeds things up during the printing to
spooler stage, and also reduces disk swaps in the Lite version.
- Added a new tooltype:
testprinter=no
If this is defined, FinalCalc will not test the printer's online status
before attempting to print. This should only be used with printer.device
replacements that always show <<Printer Busy>> or <<Printer Offline>>.
///////////////////////////////////////////////////////////////////////////////
Insert/Delete Cells:
--------------------
- Edit/Insert/Cells and Shift Right:
Shifts the current cell or range to the right and adjusts all references
to it in the project.
- Edit/Insert/Cells and Shift Down:
Shifts the current cell or range to down and adjusts all references to it
in the project.
- Edit/Delete/Cells and Shift Left:
Deletes the current cell or range, and shifts all the cells to the right
of it in its place.
- Edit/Delete/Cells and Shift Up:
Deletes the current cell or range, and shifts all the cells below it it
in its place.
- Added the following script commands to do the above actions:
INSERT CELLS_RIGHT
INSERT CELLS_DOWN
DELETE CELLS_LEFT
DELETE CELLS_UP
///////////////////////////////////////////////////////////////////////////////
Relative Cell Names:
--------------------
Added four fixed functions that point to the cell above, below, to the left
or right of the current cell.
ABOVE =HERE(-1,0)
BELOW =HERE(1,0)
LEFT =HERE(0,-1)
RIGHT =HERE(0,1)
These can be used in any formula and will return the value or the address
of the cell required.
For example:
=ABOVE+1 returns the value of the cell above plus 1.
=COL(LEFT) returns the column of the cell to the left.
These relative cell names are handled correctly by the Minimal Recalc and
are not 'live' cells, i.e. they are only recalculated if the value of the
cell they are pointing to changes, unlike the HERE() function which is
recalculated at every recalc.
///////////////////////////////////////////////////////////////////////////////
Spool Path:
-----------
You can now set FinalCalc to store its print spooler files and print
preview files to a disk device instead of the RAM disk.
To set the spool path, add the following tooltype to the FinalCalc or
FinalCalc.FPU program icon:
"spoolpath=work:myspoolpath"
where work:myspoolpath is the directory to store spool and preview files in.
FinalCalc checks to see how much space is available on the destination
device when printing a print job to the spooler. If it is set to the default
path (the RAM disk), it will abort the job if free RAM drops below 100k. If
it is set to a path on a disk device, it will abort the job if free space on
the device drops to below 20k.
In either case, you will be informed of that and will be offered a Help
button that calls up a guide section on the Spool Path.
///////////////////////////////////////////////////////////////////////////////
Other changes:
--------------
- FinalCalc now supports accented characters when editing a cell. Dead keys
are stored and attached to the next character (e.g. Alt-K then 'E').
- Sheet Views now have a small display to the left of the 'Changes' indictor.
If a range is active, and there are 2 or more numeric cells in the current
range, the sum of those numeric cells and their count is shown.
If you do not want this display, add the following tooltype to the program
icon: "rangeinfo=no"
- FinalCalc now keeps track of the last column and row used in a sheet and
uses those as the limit to range scans in many places:
- Copy/Cut range.
- Copy range to clipboard.
- The recalc minimal scan. (e.g. if you refer to a range like a1:a1000,
and the last used row is 200, it will only scan a1:a200). This speeds
up the background recalc if you use large ranges that extend beyond
the active sheet data.
- SUM(), AVG(), COUNT(), MAX(), MIN(), PROD(), FIRST(), LAST(), and PICK()
functions. (e.g. if you use sum(a1:a1000) and the last used row is 200,
it does a sum(a1:a200) instead.) Note that this doesn't apply to CSUM()
and FSUM() type functions, as they might reference offset cells, so the
test would have broken them.
This means that you can use a formula like =sum(a1:a2000) for a sheet that
you keep adding rows of data to, and you would have no performance hit as
it would only scan and sum up to the last row used.
- Text Import and Paste from Clipboard now strip all ANSI/ISO escape sequences
from the source text so that they don't mess up the imported text.
- If you use Project-Open and the current project is totally empty (fresh,
no cells, no changes, and named "Untitled"), that project is closed and
a new one is loaded in its place. This prevents an empty project staying
around if you use Project-Open to load projects.
- The Paste Function requester (Amiga-F when editing a formula) now has
a box that shows the format of the function highlighted and also has a
Details button that brings up the online help document for that function.
- In the Edit User Interface Preferences requester, Default Cell Text Color and
Background View Color now have sliders that range from 0 to 15, and show the
selected color live next to each gadget as the sliders are changed.
///////////////////////////////////////////////////////////////////////////////
Script Commands:
----------------
- Added a new script command: PASTEFUNCTION. It brings up the Paste Function
requester, and then pastes the selection into the current cell, starting
a new formula with the function selected. Its main purpose is for a new
'paste function' icon which calls the Paste Function requester in or outside
the cell edit mode.
- Rewrote the SOLVE script command:
- It now supports string formulas. Note that if you want to use double-
quotes within your formula, you should surround the formula with
single-quotes, for example: SOLVE 'repeat("test ",2)'
- Direct cell references now work.
- The HERE keyword now works. (e.g. SOLVE "col(here)")
- Added two new QUERY script commands:
- QUERY COLUMN (or QUERY COL):
returns the current column's name. (e.g. "A")
- QUERY ROW:
returns the current row's number.
///////////////////////////////////////////////////////////////////////////////
If you have any questions, our support lines are open as usual. You can also
post them in the SoftWood section in the AmigaVendor forum on Compuserve,
or e-mail Khalid Aldoseri on 71277.2776@compuserve.com.
Softwood.